newbie match question

[shawjames]

newbie syntax question:

how do I match something that is not a number in mysql?

item is "yxz123x5"
item is "yxz123x11"
item is "yxz123"

I want to select only the "xyz123" and not any of the others that have "%x(some number)"

I would put:

where item not like "%x%"? this would select them all...

I could do
where item not like "%x5" and item not like "%x11"

but then there are some that might be x12... can I wild card match anything that is a number?

[pohopo]

If yxz123 is always 6 characters then you can do

WHERE LENGTH(field) = 6

Check out string functions as it might be able to use LEFT, RIGHT, LOCATE, MID, etc to get what you need.