amalosoul Posted November 2, 2006 Share Posted November 2, 2006 I have a column in my MySQL table called name varchar(20). Can I search a value in this table by using a substring which is part of a string from this column name?(For example if I forget the whole name I want my query to display all names that begin, contain, or end with certain letters)...Thank you in anticipation! Link to comment https://forums.phpfreaks.com/topic/25989-can-this-be-done/ Share on other sites More sharing options...
fenway Posted November 2, 2006 Share Posted November 2, 2006 Yes, you can use the wildcards _ and % to match one or many characters at any position in the field. Link to comment https://forums.phpfreaks.com/topic/25989-can-this-be-done/#findComment-118780 Share on other sites More sharing options...
amalosoul Posted November 4, 2006 Author Share Posted November 4, 2006 Thank you! Link to comment https://forums.phpfreaks.com/topic/25989-can-this-be-done/#findComment-119550 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.