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! Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
amalosoul Posted November 4, 2006 Author Share Posted November 4, 2006 Thank you! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.