প্রথমে একটি টেবিল তৈরি করি:
mysql> create table DemoTable651 (Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, Value varchar(100)); Query OK, 0 rows affected (0.59 sec)
কিছু রেকর্ড ইনসার্ট করি:
mysql> insert into DemoTable651(Value) values('Title');
Query OK, 1 row affected (0.13 sec)
mysql> insert into DemoTable651(Value) values('course');
Query OK, 1 row affected (0.26 sec)
mysql> insert into DemoTable651(Value) values('subject');
Query OK, 1 row affected (0.20 sec)
সব রেকর্ড দেখি:
mysql> select *from DemoTable651;
আউটপুট:
+----+---------+ | Id | Value | +----+---------+ | 1 | Title | | 2 | course | | 3 | subject | +----+---------+ 3 rows in set (0.00 sec)
LIKE ব্যবহার করে সার্চ:
mysql> select *from DemoTable651 where Value LIKE 'course';
আউটপুট:
+----+--------+ | Id | Value | +----+--------+ | 2 | course | +----+--------+ 1 row in set (0.00 sec)
REGEXP ব্যবহার করে সার্চ:
mysql> select *from DemoTable651 where Value REGEXP 'course';
আউটপুট:
+----+--------+ | Id | Value | +----+--------+ | 2 | course | +----+--------+ 1 row in set (0.00 sec)
