select where 1

[Tracy3e]

I need to do a query that finds entries matching a string, and one position in the string varies.

If you use the % option, it matches zero or more characters. I need the % to vary only on exactly one character in the string.

I hope I am explaining myself well enough.

 

[sleipnir214]

According to

http://dev.mysql.com/doc/mysql/en/string-comparison-functions.html

"_" matches any single character


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[Tracy3e]

Sweet! That's exactly what I need.

Thanks for the fast response.