Simple MYSQL question
Posted: Sat Sep 23, 2006 10:27 am
Hi
I'm sure this is easy to answer...
I have a varchar field in mysql that contains some numbers e.g.: 4, 3, 1, 2 seperated by commas. I want to search the data base and select only the rows that contain one number from that field. For example, select all the rows from table where field contains number 4. Anyone know the syntax for that? How can mysql scan the field and see if number 4 is in it?
Larry.
I'm sure this is easy to answer...
I have a varchar field in mysql that contains some numbers e.g.: 4, 3, 1, 2 seperated by commas. I want to search the data base and select only the rows that contain one number from that field. For example, select all the rows from table where field contains number 4. Anyone know the syntax for that? How can mysql scan the field and see if number 4 is in it?
Larry.