How to get records from a table with a string column where values of the string column starts with a given substring?

Question

Example - Sub string is "ab" And if the contents are

abhi
babu
abdullah

Then after running the query I should be getting only the values

abhi 
abdullah

Even though value 'babu' contains the sub string ab

Suppose the table name is person and the column name is name

Himanshu · Accepted Answer · 2012-09-17 11:42:07Z

2

You can use LIKE operator like this:

SELECT * FROM person
WHERE name LIKE 'ab%'

If you add % ahead of ab then babu will also come in result so only add % after ab.

answered Sep 17, 2012 at 11:36

Himanshu

32.8k32 gold badges117 silver badges137 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Farnabaz · Accepted Answer · 2012-09-17 11:37:31Z

1

Use sql LIKE operator

SELECT name FROM person WHERE name LIKE 'ab%'

above query return all name starting with ab, if you want to get names like hiabhi use like this

SELECT name FROM person WHERE name LIKE '%ab%'

answered Sep 17, 2012 at 11:37

Farnabaz

4,0662 gold badges25 silver badges42 bronze badges