Question: The code that i tried is 

```
ALTER TABLE "STUDENT" RENAME COLUMN "Roll" TO "Num";

```

Its syntax is correct but it shows a error. Whats the problem?

> 
> Error
> 
> 
> Static analysis:
> 
> 
> 1 errors were found during analysis.
> 
> 
> Missing comma before start of a new alter operation. (near "TO" at position 47)
>  SQL query: Copy
> 
> 
> 

```
ALTER TABLE "STUDENT" RENAME COLUMN "column 1" TO "column 2"

```

MySQL said: Documentation

> 
> 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"STUDENT" RENAME COLUMN "column 1" TO "column 2"' at line 1
> 
> 
>

Answer: 
Hi here use this query 

```
SELECT * FROM `table_1` INNER JOIN table_2 ON table_1.var_1  WHERE `table_1.var_1` LIKE '%search%' OR table_2.var_2 = '%search2%'

```

and let me know if any error 

first use table one condition and then use " OR " & " AND " for as per your condition
Perhaps a cross join with a locate would suit

```
DROP TABLE IF EXISTS T,T1;
CREATE TABLE T(VAL VARCHAR(20));
CREATE TABLE T1(VAL VARCHAR(20));

INSERT INTO T VALUES ('ABCDEF');
INSERT INTO T1 VALUES ('AB');

SELECT T.*
FROM T
CROSS JOIN T1 
WHERE LOCATE(T1.VAL,T.VAL) > 0;

--------+
| VAL    |
+--------+
| ABCDEF |
+--------+
1 row in set (0.001 sec)

```