ego0 Posted January 30, 2006 Share Posted January 30, 2006 I have a book about SQL 'SQL for Dummies' to be specific and I have found the keywords 'LIKE' and 'NOT LIKE' and I was wondering if this can be used in MYSQL syntax? (Need to know for usage in PHP script) Link to comment https://forums.phpfreaks.com/topic/3284-select-like-something/ Share on other sites More sharing options...
fenway Posted January 30, 2006 Share Posted January 30, 2006 Sure... SELECT * FROM yourTable WHERE yourField LIKE 'j%' will retrieve anything that starts with a 'j'. Note that if you start with a wildcard, you won't be able to use an index. Link to comment https://forums.phpfreaks.com/topic/3284-select-like-something/#findComment-11201 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.