Using SQL LIKE
LIKE
When we covered the WHERE statement, we also mentioned the Sql LIKE word with an example. Let’s explain a little more now. It is used to sort the records we select from the tables.
Example use;
SELECT * From uye WHERE kullanici LIKE 'a%'In our application, we got the information of the users whose username starts with a in the uyeler table. If we think for the word Armada, we get A. Here %a means that no letter after the letter %a is not important.
%a –> calls records ending with a,
a%–> calls records starting with a,
%a% –> calls records with a in them.
MAKE A COMMENT
COMMENTS - 0 COMMENTS