I have a database that's setup in the following way\[code\]id coach team event status14 test 8,7,12,13,15 4,1,2,14,4 2 13 test 8,12,13,14,15,16 1,2,8,16,16 3 \[/code\]What i need to do, is search for rows where the first number in the "event" column matches the query. They are separated by commas, but it can be 1 or 2 or 3 digits. Im sure this is possible, just not sure how or where to begin.
searching mySQL by first char(s) in fields with php
- Thread starter RFEF
- Start date