Search using only part of the string

Question

Under a column named "name" I have a row which holds the value "Joe".

What can I use so when I search "Joe Bloggs" it will return the row that only holds "Joe"?

trincot · Accepted Answer · 2016-04-23 19:23:47Z

2

You could do this:

SELECT *
FROM   mytable
WHERE  INSTR(:value, name) > 0

Where :value should be the parameter you will bind to that SQL statement.

answered Apr 23, 2016 at 19:23

trincot

357k38 gold badges282 silver badges338 bronze badges

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

Comments

Gordon Linoff · Accepted Answer · 2016-04-23 20:15:13Z

0

You can also use LIKE:

select *
from t
where $value like concat('%', name, '%');

If you want the name "Joe" only at the beginning:

select *
from t
where $value like concat(name, '%');

answered Apr 23, 2016 at 20:15

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges