Welcome Guest, Not a member yet? Register   Sign In
Active Record : LIKE without wildcard (%)
#10

[eluser]danmontgomery[/eluser]
[quote author="Aken" date="1327970940"]
Code:
$this->db->like('column', 'value', 'none');
Is identical to:
Code:
$this->db->where('column', 'value');
At least in MySQL it is. I'd recommend using a direct comparison if you don't need the benefits the LIKE command gives you (such as the percent characters).[/quote]

LIKE is case insensitive, WHERE is not


Messages In This Thread
Active Record : LIKE without wildcard (%) - by El Forum - 01-29-2012, 04:07 AM
Active Record : LIKE without wildcard (%) - by El Forum - 01-29-2012, 12:40 PM
Active Record : LIKE without wildcard (%) - by El Forum - 01-29-2012, 10:51 PM
Active Record : LIKE without wildcard (%) - by El Forum - 01-30-2012, 06:50 AM
Active Record : LIKE without wildcard (%) - by El Forum - 01-30-2012, 09:02 AM
Active Record : LIKE without wildcard (%) - by El Forum - 01-30-2012, 05:49 PM
Active Record : LIKE without wildcard (%) - by El Forum - 01-30-2012, 11:00 PM
Active Record : LIKE without wildcard (%) - by El Forum - 01-31-2012, 12:08 AM
Active Record : LIKE without wildcard (%) - by El Forum - 01-31-2012, 12:56 AM
Active Record : LIKE without wildcard (%) - by El Forum - 01-31-2012, 09:24 AM



Theme © iAndrew 2016 - Forum software by © MyBB