MySQL sorgusu: alan Verilen php dizesindeki karakter yapılmış satırlar dönmek

0 Cevap php

I am looking for a mysql query which will return me all the rows,
where a particular field is made up of characters from a given string.

e.g. I 've this string: $input = 'abcdef';
now, I am looking for mysql to result all those rows, where e.g. 'name' consists of letters from $input.

Ben açıkça kendimi ifade umut .. :)

EDIT: Also, for the query you suggest, will it really improve performance, if we are just searching for strings made of letters a-z instead of some patterns, esp. when we are requesting data every 2 seconds.
The thing is that for now, my requirements are to only search among numeric, alpha or alphanumeric formats.. I will be using the exclusive patterns later on.

Regards
Nikhil Gupta

0 Cevap