Database

Abdul-Rhman Alsri wrote:

related words for mobile word

select ID from Table where column like '% mobile %'
                        or column like '% mobilization %'
                        or column like '% mobility %'
;

SELECT a.id AS [CampaignID],
       b.id AS [ZoneID],
       a.adheadline,
       a.adtext,
       a.displayurl,
       a.targeturl
FROM   adcampaign a
       INNER JOIN adzone b
         ON a.sitecategory = b.category
            AND a.LANGUAGE = b.LANGUAGE
            AND a.keyword LIKE '%' + b.keyword + '%';  

SELECT id FROM AdCampaign WHERE FREETEXT(Keyword, 'going');

select a.* from AdCampaign a inner join Adzone b
on a.category=b.sitecategory and a.language=b.language and a.keyword=b.keyword;

'%'+b.keyword+'%'

USE pubs<br />
IF EXISTS (SELECT name FROM sysobjects <br />
      WHERE name = 'au_info2' AND type = 'P')<br />
   DROP PROCEDURE au_info2<br />
GO<br />
USE pubs<br />
GO<br />
CREATE PROCEDURE au_info2<br />
   @lastname varchar(30) = 'D%',<br />
   @firstname varchar(18) = '%'<br />
AS <br />
SELECT au_lname, au_fname, title, pub_name<br />
FROM authors a INNER JOIN titleauthor ta<br />
   ON a.au_id = ta.au_id INNER JOIN titles t<br />
   ON t.title_id = ta.title_id INNER JOIN publishers p<br />
   ON t.pub_id = p.pub_id<br />
WHERE au_fname LIKE @firstname<br />
   AND au_lname LIKE @lastname