Programming for Everybody: SQL SELECT WHERE field contains words and Specific value

SQL SELECT WHERE field contains words and Specific value

 SQL SELECT WHERE field contains words
SELECT     n1, title, address
FROM         pages
WHERE     (
title LIKE '%Morad%') 

Specific value
 
SELECT     n1, title, address
FROM         pages
WHERE     (
title= 'Morad Gamal')

No comments:

Post a Comment