
January 26th, 2017, 12:45 AM
|
Registered User
|
|
Join Date: Jan 2017
Location: Ahmedabad
Posts: 24
Time spent in forums: 11 h 8 m 8 sec
Reputation Power: 0
|
|
SQL Related Query
Hi,
You can try this query to count the number of 'i' in word philippines in MySql,
Code:
begin
DECLARE @word varchar(50) = 'philippines';
DECLARE @pattern varchar(50) = 'i';
select len(@word)
len(replace(@word,@pattern,''))
end
Thanks,
|